Utilities Professional 1-1500/Utilities Professional 1-1500 (1994)(WPD)[!].iso/12511500/var1356.dms/var1356.adf/FHSPREAD/FHS_Manual

Text File | 1992-09-02 | 15KB | 474 lines

    FHS-manual Version 0.3  27-11-1993            FHSpread V2.01


    1.ABOUT FHSPREAD:

    1.1.THE PROGRAM:

        This program is publicdomain. You may distribute as many
        copies as you wish, but please don't ask for more than
        the price of a floppy in return. This document must also
        always be included.

        The program is written in GFABASIC and compiled with
        it's GFA-compiler. The reason why I wrote this program
        is, that I just needed a good spreadsheet.

    1.2.BUGREPORTS & UPDATES:

        If you've found some bugs during using it, please let me
        know by sending your bug-report to:

        Frank Hartog
        Indischestraat 45
        2022 VP  Haarlem
        The Netherlands

        If you want the latest update, pleas send:

        -An envelope with your name & address and something that
         covers the costs of having it send back to you.
        -An EMPTY floppy.
        (- A small token of appreciation (Preferably in dollars)
         By including the above, you will expedite a quicker
         response.)
        Please also state which version you use.
        Than I will send you the latest update of FHSPREAD as
        soon as possible.
        If you have included a fee, I will also let you know when
        a new version is available.


    1.3.GETTING STARTED:

        If you want to copy the program you only have to copy the
        FHSPREAD-drawer to the disk or directory you wish. The
        FHSPREAD-drawer must contain the following files:
        FHS               :this is the executable program.
        FHS_Historyfile   :this is a text document.
        FHS_Manual        :this is the file you are looking at
                           right now.
        FHHC              :this program needs to be in the same
                           drawer as FHS if you want to make a
                           hardcopy.


        To start FHS, you can select its icon or an icon of
        another FHS-sheetfile. You can also start FHS from CLI
        followed by the name of a FHS-sheetfile, the sheet will
        then be automatically loaded.

        !! If an ERROR 26 occurs during program start up, just
           delete the FHS_prefs file and after that FHS should
           work fine !!!



    2.THE MENU:

        In the following chapter all the menu items will be
        explained, starting with the extreme left and ending
        with the extreme right menu. (Thanks to a special
        calculation algorithm, there is no need for a special
        menu-item to adjust the iteration, because there is no
        need for iteration.)


    2.1.FHSPREAD V2.0:

    2.1.1.ABOUT:

        Will introduceyou to the author of the program, and
        details about the version of the program.

    2.1.2.NEW:

        Will erase the current sheet and clean the memory, but
        before this, it shows a requester to prompt if you are
        sure of this step in case you make an error.

    2.1.3.LOAD:

        Will load an existing sheet, which must be a FHS-file,
        using a filerequestor.

    2.1.4.SAVE AS:

        Will write the current sheet to a disk or wherever you
        wish to write it to, using a file requestor.

    2.1.5.SAVE:

        Will (over)write the current sheet. If you have not
        written the sheet before, the program will show the file
        requestor.

    2.1.6.DELETE:

        Will delete a file which is selected using the file
        requester. Before deleting the file, the program will
        prompt for confirmation.

    2.1.7.PRINT:

        Will pop up a print window in which you can set:

        LEFT border offset,
        RIGHT border offset,
        TOP margin,
        BOTTOM margin,
        PAGE length,
        RANGE of the cells you want to print,
        NLQ on/off  nearletterquality,
        DSTRK on/off doublestrike the protected cells.
        PRINT print the range of cells to a printerdevice or
        to a file.
        CANCEL will leave the print window.

        These items can be selected pressing the buttons with
        a mouse or by pressing the highlighted keys.

    2.1.8.QUIT:

        Ques what, this option will quit the program.

    2.2.SHEET:

    2.2.1.COLUMN:

        Will let you set the width of the column which is
        indicated by the current cursor position.
        Default width is 10.

    2.2.2.MOVE:

        Will move a selected range of cells to another position in
        the sheet. The incremental cell pointers in the cell will
        also change.

    2.2.3.COPY:

        Will copy a selected range of cells to another position in
        the sheet. The incremental cell pointers in the cell will
        also change.

    2.2.4.ERASE:

        Will erase a selected range of cells.

    2.2.5.GOTO:

        Will let you jump to a specific position in the sheet, so
        you  don't have to scroll all the way to it.

    2.3.FORMAT:

        The menu items below will work in the following sequence:
        First select the menu-item from the menu, then select
        a range of cells after which, the selected cells will be
        changed or adjusted according to the selection chosen.

    2.3.1.LEFT:

        Will align the selected cells to the left of their
        column.

    2.3.2.RIGHT:

        Will align the selected cells to the right of their
        column.


    2.3.3.CENTER:

        Will center the selected cells of their column.


    2.3.4.CURRENCY:

        Will print the numeric cells in a currency notation.

    2.3.5.NORMAL:

        Reset the selected cells.

    2.3.6.FIXED:

        Defines a selected range of cells with a fixed number of
        decimal places.

    2.3.7.PROCENTS:

        Will print the value of a numeric cell as a percentage.
        e.g. `0.89' will be shown as `89 %'.

    2.3.8.HIDE:

        Will hide the selected cells. Where the cells contain a
        data they can be made visible with the next option.

    2.3.9.UNHIDE:

        Will make the hidden cells visible again.

    2.3.10.PROTECT:

        This will protect the selected cells from being
        overwritten. This will only be active if the option
        PROTECT ON is selected in the PREFS-menu.
        The selected cells will be printed in black.

    2.3.11.UNPROTECT:

        This will make the protected cells unprotected.

    2.4.LABEL:

       If you have created more than one label, you can use them
       in the formulas. When you have created a label of only
       one cell, you can use that label as a value. Otherwise
       you can use it as a standard range with for example the
       commands SUM or AVG.

    2.4.1.CREATE:

        Will let you create a new label:
        First select CREATE from the menu,
        type in the name which you want to assign to the label
        and select a range of cells.
        You can create a maximum of twenty labels.
        If you select only one cell, the label will be used as
        a numeric value.

    2.4.2.DELETE:

        Will show you the existing labels. A label can be deleted
        by selecting the labelname or by typing the number of the
        label and entering it with the return key.
        In cells, which referred to the label that was deleted, the
        name of the label will be replaced by the range or the
        cellpointer to which the label referred to.
        To leave the window press the right mousebutton or hit
        the return key.

    2.4.3.SHOW:

        Will show the existing labels.
        To leave the window press return or press the
        left mousebutton.

    2.5.GRAPH:

    2.5.1.VIEW:

        Gives you a graphical representation of the selected
        ranges, selected with the menu-items which are explained
        in the following paragraphs.

    2.5.2.TYPE:

        Selecting the type of graphical presentation:
        -LINE     : Connects every point with a line.
                    Each different line will have a different
                    pattern.
        -BAR      : Every value will be presented as a bar.
                    Each Bar of a different range will have
                    a different pattern.
        -STRAIGHT : One straight line will be drawn through al the
                    points. Each different line will have a
                    different pattern.

    2.5.3.PRINT:

        Will dump your graphical representation to a printer.
        (Hardcopy).

    2.5.4.SAVEIFF:

        Will write your graphical representation as an IFF-file to
        a disk.

    2.5.5.X:

        Select the range of cells which will be displayed as the
        X-axis on your graphical presentation.

    2.5.6.ABCDE:

        Select the ranges of cells which will be displayed as the
        Y-axis on your graphical representation.

    2.5.7.TITLES:

        Will show a window in which you can give every axis a
        name and give your whole graphical representation a title.
        To leave the window, none of the bars must be active.
        Press return or place the mousepointer to the window
        and press the mousebutton then hit the space bar or press
        both mousebuttons.

    2.6.PREFS:

    2.6.1.LACED/HIRES:

        Will switch between a laced or a hires screen.

    2.6.2.AUTOCALC:

        Will switch on/off the automatic recalculation of the
        sheet every time a numeric value or a formula is entered.
        When this option is off you can recalculate the sheet by
        pressing function key number ten (F10).

    2.6.3.TASKPRI:

        This menu-item will let you select task priority. You can
        choose between +1,0 and -1 by selecting the value in its
        submenu.

    2.6.4.WORKBENCH:

        Will let you switch on/off the workbench (if possible)
        to obtain some extra memory.

    2.6.5.PROTECTION ON:

        If this option is on, the protected cells cannot be
        re-entered.

    2.6.6.NTSC/PAL:

        Switches the sheet to PAL or NTSC.

    2.6.7.WBSCREEN/COSTUMSCREEN:

        When WBSCREEN is selected, FHS will use a resizeable window
        on your workbench. If COSTUMSCREEN is selected, FHS will
        use its own screen.

    2.6.8.CURRENCY:

        Lets you change the way in which you want to express your
        currency. Default is F, that stands for Dutch florin or
        Dutch gilders.


    2.6.9.SAVE ICON:

        If switched on, it saves an icon with your FHS-sheet
        file.

    2.6.10.LOAD PREFS:

        Let you load an already saved preference setting.

    2.6.11.SAVE PREFS:

        Writes your prefs setting to the directory from which FHS
        is started.

    2.7.KEYBOARD EQUIVALENTS:

        For almost every menu-item there is a keyboard
        equivalent. What they are can be seen by selecting a
        menu-item with your mouse.

        There are three variations:

        1. Amiga sign + character means:  right amiga button +
           character
        2. A + character1 - character2   means:  First press both
           Alt + character1  then press character2.
        3. C + character1 - character2   means:  First press both
           Ctrl + character1  then press character2.

    3.AVAILABLE FUNCTIONS:

        In this chapter all available functions are listed:

        SIN(val)      = Calculates the sine in radians.
        ASIN(val)     = Calculates the arcsine in radians.
        COS(val)      = Calculates the cosine in radians.
        ACOS(val)     = Calculates the arccosine in radians.
        TAN(val)      = Calculates the tangent in radians.
        ATN(val)      = Calculates the arctangent in radians.

        RAD(val)      = Changes degrees to radians.
        DEG(val)      = Changes radians to dergees.

        ROUND(val,n)  = Will round a numeric value to n digits.
        MOD(val,n)    = Will give the modulus n of val.

        RANDOM(val)   = Wil generate a random value between zero
                        and val.
        EXP(val)      = Calculates e^val.
        LOG(val)      = Calculates the natural logarithm of val.
        LOG10(val)    = Calculates the (LOG(val)/LOG(10)).

        FACT(val)     = Calculates val!
        VARIAT(val,n) = Calculates val!/(val-n)!
        COMBIN(val,n) = Calculates val!/((val-n)!*n!)


        AVG(list)     = Will calculate the average of all values
                        in the list.
                        'example  (AVG(A1..B3))'
        SUM(list)     = Will sum all values in the list.
                        'example  (SUM(A1..B3))'
        COUNT(list)   = Will count the number of used cells in
                        the list.
                        'example  (COUNT(A1..B3))'

        There are also three constant values:

        PI            = Will return the value of 3.14....etc.
        ( FALSE       = Will return a '0'.
          TRUE        = Will return a '-1'. these will be used
                        in future versions.  )

        Use F10 (function key number 10) to recalculate the
        spreadsheet.

    4.ENTERING DATA:

        Use F2 (function key number 2) to change the items of a
        cell. You can also use this on an empty cell.

    4.1.ENTERING TEXT:

        Place the cursor on the cell in which you want to start
        entering text. The program will recognize automatically if
        you are entering text. The default alignment is to the left,
        which can be recognised by a ' at the beginning af the
        text.
        If you want to align the text to the right you must first
        type a `.
        If you want to have the text centered you must first
        type a ^.
        If the text is longer than the width of the cell, the
        text will be printed over the empty cells next to
        the starting cell.
        Cells which already contain data will show their own
        data.
        To leave a cell you can press:-ENTER
                                      -CURSORKEY
                                      -MOUSEKEY

    4.2.ENTERING NUMERIC VALUES:

        A numeric value can be entered simply by typing a value on
        the current cell.

    4.3.ENTERING FORMULAS:

        If you want to put a formula in a cell, you must start
        by typing a '('. If you want to use values from another
        cell, just use the cursorkeys to go to the particular
        cell and enter ^,*,/,+ or - or if you want to select a
        range by pressing '.' and press the cursorkeys again.
        The program uses the usual priorities between +,- and *,/,^.

     5.0.END NOTE:

        I want to thank you to Alex Teesdale for his advise on
        writing this manual.